package com.hzqy.persistence.dao.hotel;


import com.hzqy.persistence.dao.core.PersistenceDao;
import com.hzqy.web.vo.*;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

@Repository
public class HotelDao extends PersistenceDao<PmsUserVo, Integer>{
	protected final Logger LOG = LoggerFactory.getLogger(getClass());
	
	public List<StatOutlineOrderDataVo> selectOrderDate(StatOutlineOrderDataVo statOutlineOrderDataVo) {
		return getSqlSession().selectList(this.getNamespace()+"selectOrderDate",statOutlineOrderDataVo);
	}
	
	public int selectHotelBigDataAvg(StatDataBigDataVo statDataBigDataVo) {
		return getSqlSession().selectOne(this.getNamespace()+"selectHotelBigDataAvg",statDataBigDataVo);
	}
	
	public int selectHotelBigDataMonthSum(StatDataBigDataVo statDataBigDataVo) {
		return getSqlSession().selectOne(this.getNamespace()+"selectHotelBigDataMonthSum",statDataBigDataVo);
	}
	
	public List<StatDataBigDataVo> selectHotelBigDataArea(StatDataBigDataVo statDataBigDataVo) {
		return getSqlSession().selectList(this.getNamespace()+"selectHotelBigDataArea",statDataBigDataVo);
	}
	
	public List<StatDataBigDataVo> selectHotelBigDataAreaSeven(StatDataBigDataVo statDataBigDataVo) {
		return getSqlSession().selectList(this.getNamespace()+"selectHotelBigDataAreaSeven",statDataBigDataVo);
	}
	
	public List<StatDataBigDataVo> selectHotelBigDataActivityArea(StatDataBigDataVo statDataBigDataVo) {
		return getSqlSession().selectList(this.getNamespace()+"selectHotelBigDataActivityArea",statDataBigDataVo);
	}
	
	public List<StatDataBigDataVo> selectHotelBigDataActivityProvince(StatDataBigDataVo statDataBigDataVo) {
		return getSqlSession().selectList(this.getNamespace()+"selectHotelBigDataActivityProvince",statDataBigDataVo);
	}
	
	public List<StatDataBigDataVo> selectHotelBigDataViewing(StatDataBigDataVo statDataBigDataVo) {
		return getSqlSession().selectList(this.getNamespace()+"selectHotelBigDataViewing",statDataBigDataVo);
	}
	
	public List<StatDataTotalTopRankingVo> selectHotelBigDataTop8OpenTV(StatDataTotalTopRankingVo statDataTotalTopRankingVo) {
		return getSqlSession().selectList(this.getNamespace() + "selectHotelBigDataTop8OpenTV",statDataTotalTopRankingVo);
	}
	
	public List<StatDataTotalTopRankingVo> selectHotelBigDataTop8UseTV(StatDataTotalTopRankingVo statDataTotalTopRankingVo) {
		return getSqlSession().selectList(this.getNamespace() + "selectHotelBigDataTop8UseTV",statDataTotalTopRankingVo);
	}
	
	public List<StatDataUserIncreaseAreaVo> selectHotelBigDataUserIncrease(StatDataUserIncreaseAreaVo statDataUserIncreaseAreaVo) {
		return getSqlSession().selectList(this.getNamespace()+"selectHotelBigDataUserIncrease",statDataUserIncreaseAreaVo);
	}

	public List<Map<String, Object>> selectHotelBigDataBIUserCount(StatDataBigDataVo statDataBigDataVo) {
		return getSqlSession().selectList(this.getNamespace()+"selectHotelBigDataBIUserCount", statDataBigDataVo);
	}
	
	public String selectOrgsByUserAccount(String f_cuo_userAccount) {
		return getSqlSession().selectOne(this.getNamespace()+"selectOrgsByUserAccount",f_cuo_userAccount);
	}

	public List<CmAdvertiseVo> selectHotelAdvertise(CmAdvertiseVo cmAdvertiseVo) {
		return getSqlSession().selectList(this.getNamespace()+"selectHotelAdvertise", cmAdvertiseVo);
	}

	public int updateAdvertiseStrategyStatus(CmAdvertiseVo cmAdvertiseVo) {
		return getSqlSession().update(this.getNamespace()+"updateAdvertiseStrategyStatus", cmAdvertiseVo);
	}

	public List<HotelCouponVo> selectCoupon(HotelCouponVo hotelCouponVo) {
		return getSqlSession().selectList(this.getNamespace()+"selectCoupon", hotelCouponVo);
	}

	public List<HotelCouponCodeVo> selectCouponCode(HotelCouponCodeVo hotelCouponCodeVo) {
		return getSqlSession().selectList(this.getNamespace()+"selectCouponCode", hotelCouponCodeVo);
	}

	public int updateCouponCodeStatus(int f_hcc_id) {
		return getSqlSession().update(this.getNamespace()+"updateCouponCodeStatus", f_hcc_id);
	}

	public int insertCouponOrder(HotelCouponOrderVo hotelCouponOrderVo) {
		return getSqlSession().insert(this.getNamespace()+"insertCouponOrder", hotelCouponOrderVo);
	}

	public int updateCouponOrder(HotelCouponOrderVo hotelCouponOrderVo) {
		return getSqlSession().insert(this.getNamespace()+"updateCouponOrder", hotelCouponOrderVo);
	}

	public List<CmAdvertiseLogVo> insertHotelAdvertiseLog(CmAdvertiseLogVo cmAdvertiseLogVo) {
		return getSqlSession().selectList(this.getNamespace()+"insertHotelAdvertiseLog", cmAdvertiseLogVo);
	}

	public List<CmAdvertiseVo> selectHotelAdvertiseById(CmAdvertiseVo cmAdvertiseVo) {
		return getSqlSession().selectList(this.getNamespace()+"selectHotelAdvertiseById", cmAdvertiseVo);
	}

	public List<CmAdvertiseVo> selectHotelAdvertiseStrategyById(CmAdvertiseVo cmAdvertiseVo) {
		return getSqlSession().selectList(this.getNamespace()+"selectHotelAdvertiseStrategyById", cmAdvertiseVo);
	}

	public List<CmContentOrgVo> selectOrgBind(int f_cco_contentId) {
		return getSqlSession().selectList(this.getNamespace() + "selectOrgBind",f_cco_contentId);
	}
}
